﻿CREATE TABLE [dbo].[Order_bak] (
    [Id]                 INT              NOT NULL,
    [OId]                UNIQUEIDENTIFIER NULL,
    [OrderId]            NVARCHAR (50)    NULL,
    [CusId]              UNIQUEIDENTIFIER NULL,
    [CusName]            NVARCHAR (200)   NULL,
    [CusName_BD]         NVARCHAR (100)   NULL,
    [CusPerson]          NVARCHAR (50)    NULL,
    [CusPersonTel]       NVARCHAR (50)    NULL,
    [CusDescription]     NVARCHAR (MAX)   NULL,
    [CusEstimate]        NVARCHAR (200)   NULL,
    [TypeId]             INT              NULL,
    [TypeName]           NVARCHAR (50)    NULL,
    [WayId]              INT              NULL,
    [WayName]            NVARCHAR (50)    NULL,
    [ProcessId]          INT              NULL,
    [ProcessName]        NVARCHAR (50)    NULL,
    [Salesman]           NVARCHAR (50)    NULL,
    [SalesmanAccount]    NVARCHAR (50)    NULL,
    [TradeDate]          DATETIME         NULL,
    [CreateDate]         DATETIME         NULL,
    [YingShouPrice]      DECIMAL (18, 2)  NOT NULL,
    [ShiShouPrice]       DECIMAL (18, 2)  NOT NULL,
    [Discount]           NVARCHAR (50)    NULL,
    [PaymentTypeId]      INT              NULL,
    [PaymentType]        NVARCHAR (50)    NULL,
    [BankId]             INT              NULL,
    [Bank]               NVARCHAR (50)    NULL,
    [PaymentDescription] NVARCHAR (200)   NULL,
    [OtherDescription]   NVARCHAR (1000)  NULL,
    [DepId]              INT              NULL,
    [CompanyId]          INT              NULL,
    [StateId]            INT              NULL,
    [FinanceRenlingDate] DATETIME         NULL,
    [IsGreen]            BIT              NULL,
    [TrackKfAccount]     NVARCHAR (50)    NULL,
    [TrackKfName]        NVARCHAR (50)    NULL,
    [TrackKfDepId]       INT              NULL,
    [GenJinKfAccount]    VARCHAR (30)     NULL,
    [GenJinKfName]       NVARCHAR (50)    NULL,
    [GenJinKfDepId]      INT              NULL,
    [flag]               INT              NULL,
    [AuditPerson]        NVARCHAR (50)    NULL,
    [AuditDate]          DATETIME         NULL,
    [shjbh]              NVARCHAR (50)    NULL,
    [htbh]               NVARCHAR (50)    NULL,
    [NOE_Flag]           INT              NOT NULL,
    [ExCompanyId]        INT              NOT NULL,
    [FinishDate]         DATETIME         NULL,
    [F_YingShou]         DECIMAL (18, 2)  NOT NULL,
    [TrackBDAccount]     VARCHAR (50)     NULL,
    [TrackBDName]        NVARCHAR (50)    NULL,
    [Analyse]            NVARCHAR (50)    NULL,
    [RCount]             INT              NULL,
    [H_YingShou]         DECIMAL (18, 2)  NULL,
    [reserve1]           INT              NULL,
    [reserve2]           INT              NULL,
    [reserve3]           DECIMAL (18, 2)  NULL,
    [reserve4]           DECIMAL (18, 2)  NULL,
    [reserve5]           VARCHAR (50)     NULL,
    [reserve6]           VARCHAR (50)     NULL,
    CONSTRAINT [PK_Order_bak] PRIMARY KEY CLUSTERED ([Id] ASC)
);

